package com.model;

import com.util.DB;

public class bank {
	
	     
	private String payeename;
	private Integer accntno;
	


	private String bankname;
	private String city;
	private String branch;
	private Integer mcir;
	
	private Integer creditcardno;
	private String month;
	private Integer year;
	private String cardholder;
	private Integer cvv; 
	
private Float balance;
	
	
	


	public Float getBalance() {
		return balance;
	}



	public void setBalance(Float balance) {
		this.balance = balance;
	}



	public Integer getCreditcardno() {
		return creditcardno;
	}



	public void setCreditcardno(Integer creditcardno) {
		this.creditcardno = creditcardno;
	}



	public String getMonth() {
		return month;
	}



	public void setMonth(String month) {
		this.month = month;
	}



	public Integer getYear() {
		return year;
	}



	public void setYear(Integer year) {
		this.year = year;
	}



	public String getCardholder() {
		return cardholder;
	}



	public void setCardholder(String cardholder) {
		this.cardholder = cardholder;
	}



	public Integer getCvv() {
		return cvv;
	}



	public void setCvv(Integer cvv) {
		this.cvv = cvv;
	}


	
	
	public String getPayeename() {
		return payeename;
	}



	public void setPayeename(String payeename) {
		this.payeename = payeename;
	}


	

	public Integer getAccntno() {
		return accntno;
	}



	public void setAccntno(Integer accntno) {
		this.accntno = accntno;
	}



	public Integer getMcir() {
		return mcir;
	}



	public void setMcir(Integer mcir) {
		this.mcir = mcir;
	}





	public String getBankname() {
		return bankname;
	}



	public void setBankname(String bankname) {
		this.bankname = bankname;
	}



	public String getCity() {
		return city;
	}



	public void setCity(String city) {
		this.city = city;
	}



	public String getBranch() {
		return branch;
	}



	public void setBranch(String branch) {
		this.branch = branch;
	}


		
		public int insert()
		{
			
			String insertQuery = "insert into bank "
				+ "(payeename,accntno,bankname,city,branch,mcir,creditcardno,month,year,cardholder,cvv,balance) " + "values('"+payeename
				+ "', " + accntno + ", '"+bankname+"','" +city+ "','" + branch+ "'," +mcir+","+creditcardno+",'"+month+"',"+year+",'"+cardholder+"',"+cvv+","+balance +");";
			
			
			return DB.update(insertQuery);
		}

		
}
